<h1 class="top">Alias variable</h1>
<h2>The block</h2>
<img src="help/img/fieldname_get.png" alt="Alias block" class="leftFloatIMG">
<p class="leftFloat left">
  This block symbolises the alias of a 
  <span class="groupLinks pointer" onclick="fetchthelink('Help/sub_select.html','#63a65a')">subselect</span>,
  <span class="groupLinks pointer" onclick="fetchthelink('Help/sub_select_where.html','#63a65a')">subselect </span>in the 'WHERE'-section or of the 
  <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html','#63a65a')">groupfunctions</span>.  An alias in SQL is a name for a result column.
  It is used as a value in the "ORDER BY" or "GROUP BY" -clause .
</p>
<h2> Functionality</h2>
<img src="help/img/fieldname_get_change.png" alt="Changing the alias value" class="rightFloatIMG">  
<p  class="text">At first you need to set an alias. Either you set the alias of a subselect or of one of the groupfunctions.<br> For more information about how to set an alias,
<span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html#alias','#63a65a');">click here.</span> After setting the alias the variable will be filled 
automatically with the alias, which the alias. If you set more then one alias, the first one will be default value. 
If you want to change the alias, because you defined more than one.
, you can klick on the arrow in the variable field and choose the aliasname 
    as you see in the picture on the right.</p>
<div id="aliasback" style="margin-top: 20px;"></div>


